<?php include 'dbInclude.php';?>
<table>
<tr><td>Company</td><td>LTP</td><td>Opening Price</td><td>Closing Price</td></tr>
<?php
$rows=$dbh->query("select * from market M,instrument_master I where M.INSTR_ID = I.INSTR_ID ORDER BY I.INSTR_NAME ;");
foreach ($rows as $row) {
echo "<tr>";
echo "<td>".$row['INSTR_NAME']."</td>";
echo "<td class='price'>".$row['LTP']."</td>";
echo "<td>".$row['OPENING_PRICE']."</td>";
echo "<td>".$row['CLOSING_PRICE']."</td>";
echo "</tr>";
}
?>
</table>


